﻿CREATE TABLE [BritishGas].[BritishGasCC]
(
		Id int NOT NULL Identity(1,1),
		SchoolId varchar(50) NOT NULL,
		ClassName varchar(50) NOT NULL,
        Start datetime NOT NULL,
        [End] datetime NOT NULL,
		NoOfPupils int,
        ElectricityKwh decimal (10,4),
        GasKwh decimal (10,4),
        OilKwh decimal (10,4),
        OilLitres decimal (10,4),
        Butane45 decimal (10,4),
        Butane70 decimal (10,4),
        Butane150 decimal (10,4),
        Propane39 decimal (10,4),
        Propane60 decimal (10,4),
        Propane130 decimal (10,4),
        ButanePerPupil decimal(10,4),
        ButaneTotal decimal(10,4),
        RenewablePercentage decimal(4,3),
        GreenElectricity decimal(10,4),
        SolarPanels decimal(10,4),
		WindTurbine decimal(10,4),
		RenewableOther decimal(10,4),
        ElectricityPerPupil decimal(10,4),
        ElectricityTotal decimal(10,4),
        GasPerPupil decimal(10,4),
        GasTotal decimal(10,4),
        OilKwhPerPupil decimal(10,4),
        OilKwhTotal decimal(10,4),
        PropanePerPupil decimal(10,4),
        PropaneTotal decimal(10,4),
        TonnesPerPupil decimal(10,4),
        TonnesTotal decimal(10,4),
        ConcurencyId RowVersion
        
);
